package com.maxin.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.maxin.entity.Ausertable;

public interface AusertableMapper {
	
	@Insert("insert into ausertable values(#{aname}, #{apwd})")
	int insert(Ausertable ausertable);
	
	@Delete("delete from ausertable where aname = #{aname}")
	int deleteByName(String aname);
	
	@Update("update ausertable set #{apwd} where aname = #{aname}")
	int updateByName(Ausertable ausertable);
	
	@Select("select * from ausertable where aname = #{aname}")
	Ausertable selectByName(String aname);
	
	@Select("select * from ausertable")
	List<Ausertable> selectAll();
}
